/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package cn.ekuma.epos.datalogic.define.dao;

import cn.ekuma.data.dao.ModifiedLogDAO;
import cn.ekuma.epos.db.table.I_ProductCategory;
import com.openbravo.data.basic.BasicException;
import com.openbravo.data.loader.DataRead;
import com.openbravo.data.loader.DataWrite;
import com.openbravo.data.loader.Datas;
import com.openbravo.data.loader.I_Session;
import com.openbravo.data.loader.TableDefinition;
import com.openbravo.format.Formats;
import com.openbravo.bean.ProductCategory;
import com.openbravo.data.model.Field;

/**
 *
 * @author Administrator
 */
public class ProductCategoryDAO extends ModifiedLogDAO<ProductCategory>{
   
    public ProductCategoryDAO(I_Session s) {
        super(s);
    }

    
     public TableDefinition getTable() {
         return new TableDefinition(s,
                "CATEGORIES",
                new Field[]{
                   new Field(I_ProductCategory.ID,Datas.STRING, Formats.STRING),
                   new Field(I_ProductCategory.NAME,Datas.STRING, Formats.STRING),
                   new Field(I_ProductCategory.PARENTID,Datas.STRING, Formats.STRING,ProductCategory.class),
                   new Field(I_ProductCategory.ISHOT,Datas.BOOLEAN, Formats.BOOLEAN),
                   new Field(I_ProductCategory.LASTMODIFIED,Datas.TIMESTAMP, Formats.TIMESTAMP),
                   new Field(I_ProductCategory.CREATEDATE,Datas.TIMESTAMP, Formats.TIMESTAMP)
                } ,
                new int[]{0}){
					@Override
					public String getDefaultListOrder(String alise) {
						String ret=" order by ";
						if(alise!=null)
							ret+=alise+".";
						ret+=I_ProductCategory.CREATEDATE+" ASC ";
						return ret;
					}
        	
        };
    }

    @Override
    public void writeInsertValues(DataWrite dp, ProductCategory obj) throws BasicException {
           dp.setString(1, obj.getID());
           dp.setString(2, obj.getName());
           dp.setString(3, obj.getM_sParentID());
           dp.setBoolean(4, obj.isHot());
           dp.setTimestamp(5,obj.getLastModified());
           dp.setTimestamp(6,obj.getCreateDate());
    }

    public ProductCategory readValues(DataRead dr,ProductCategory obj) throws BasicException {
        if(obj==null)
        	obj=new ProductCategory();
        obj.setID(dr.getString(1));
        obj.setName(dr.getString(2));
        obj.setM_sParentID(dr.getString(3));
        obj.setHot(dr.getBoolean(4));
        obj.setLastModified(dr.getTimestamp(5));
        obj.setCreateDate(dr.getTimestamp(6));
         return obj;
    }

    @Override
    public Class getSuportClass() {
        return ProductCategory.class;
    }
    
    
}
